﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Runda.CMS.Portal.Workspace
{
    public partial class DESK_myJoinProcess : BasePage
    {
        public override bool IsCheckAccessible
        {
            get
            {
                return false;
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                //string str = "select * from (select   * from Cms_Wfl_Task  where TaskType=0 and activityid in (select activityid from  Cms_Wfl_ActivityCheckers where userid = '" + Session["CurrentUserID"].ToString() + "')  union   select * from Cms_Wfl_Task where TaskType=1 and activityid in (select activityid from Cms_Wfl_Comment where LeaderID= '" + Session["CurrentUserID"].ToString() + "' ))  as A where Status = 0";

                string str = @"select top 10 * from Cms_Wfl_Task where [Status] = 0 and TaskID in (select TaskID from  Cms_Wfl_TaskUser where UserID = '"+CurrentUserID+"') order by CreatedOn desc";

                this.rptrDeal.BindMode = 0;
                this.rptrDeal.SQL = str;
                this.rptrDeal.DataBind();
            }
        }
    }
}
